Problem Note 64123: Batch Scheduler might not import the .AIN files as expected.
In SAS® Merchandise Allocation, the Batch Scheduler might not import the .AIN files as expected. This issue is likely to occur when the merchandise/dimension sets assigned to the saved Batch Scheduler rule are deleted. If you delete a dimension set in Dimension Manager that is used in the Batch Scheduler, then the AIN load fails.
The following exception might be generated in the catalina log:
java.util.NoSuchElementException…
[ERROR] [] com.marketmax.allocation.jdbc.MMAXAllocationJDBC - Exception getting the parent merch id for merch id 26223 at level -1
java.sql.SQLSyntaxErrorException: ORA-00904: "LV": invalid identifier…
The exception might be generated in the MAXDATA.ALLOC_INTERFACE_LOG table:
Error While Saving Allocation Definition
To work around this issue, merchandise sets that exist in the batch scheduler should not be deleted from Dimension Manager.
Operating System and Release Information
| SAS System | SAS Merchandise Allocation | Microsoft Windows Server 2012 R2 Std | 3.9 | 4.2 | 9.4 TS1M4 | 9.4 TS1M5 |
| 64-bit Enabled AIX | 3.9 | 4.2 | 9.4 TS1M4 | 9.4 TS1M5 |
| Linux for x64 | 3.9 | 4.2 | 9.4 TS1M4 | 9.4 TS1M5 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-05-02 14:00:29 |
| Date Created: | 2019-04-29 10:40:12 |